Just the same way as you would if they parameter variables, e.g. INSERT INTO AccidentMain( EmpID, DeptID, ... FName, LName, Address, City, State, ZipCode, ... ) VALUES ( @EmpID, @DeptID, ... @FName, @LName, @Address, @City, @State, @ZipCode, ... )
2003-05-30
1 reads
I can see it as part of a PK if you do a lot of time range queries, but definetely not as the only column. The risk of rejected insert because of duplicate keys seems to high. Don't forget that the datetime value is only accurate up to 3/1000 of a second.
2003-05-30
2003-05-29
1 reads
Of the two, it's normally command timeout you want to increase. There are certainly times when increasing it is the right thing to do, but do change with caution. If you set the timeout high, potentially your query will block others for that much longer. Ideally you want to tune the query first to get […]
2003-05-28
Because, by varying the server name, you are varying the object you a referring to, that is dynamic SQL. Except, we have objects that "alias" to other objects .. views to tables, linked servers to servers. So you could create a view that references what you want. Although creating the view is dynamic SQL. I […]
2003-05-28
1 reads
Another new author! Gheorge shares some ideas about importing event logs and using OLAP to analyze the results. Not a bad idea at all. How many of use OLAP as often as we should? Read the article, see if it's something you want to try - and let Gheorge know what you think!
2003-05-28
12,958 reads
Analysis services have a useful tuturial that works with foodmart2000 that will teach you the basics of creating calculated members
2003-05-27
Maintenance plan does not allow me to choose all databases on all servers but a list of DBs that are not to backup. Maintenance plan does not allow me to do differential backups. (Some DBs are large, so I can not go with weekly full backups and 10 minutes log backups) This job will be […]
2003-05-27
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-23
I guess because groups don't have a loginname. Add it to the ms-sql-wishlist.
2003-05-23
1 reads
SQL is essential for modern businesses and applications that rely on data. It's a...
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers