How to provide default values to function parameters?

1216

What are the restrictions that views have to follow? : SQL Server Architecture

1058

Why I can not enter 0.001 second in date and time literals in ms sql server?

1104

Which are ddl commands?

1112

How to include text values in sql statements?

1094

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

963

Explain rdbms?

1075

Does server sql treat char as a variable-length or fixed-length column?

1090

How much is a sql server license?

1008

What is difference between clustered index and non clustered index?

1117

How to count rows with the count(*) function in ms sql server?

1057

Can the “if update (colname)” statement be used in a delete trigger?

1032

Where do we use trace frag?

1059

Can group by and orderby be used together?

1067

List some of the rules that apply to creating and using a ‘view’

921